Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 10155 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.0 MiB |
| Average record size in memory | 208.0 B |
Variable types
| NUM | 19 |
|---|---|
| BOOL | 4 |
| CAT | 3 |
Reproduction
| Analysis started | 2020-06-12 11:46:00.892300 |
|---|---|
| Analysis finished | 2020-06-12 11:48:10.511495 |
| Duration | 2 minutes and 9.62 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Portfolio Balance is highly correlated with Investment in Derivative | High correlation |
Investment in Derivative is highly correlated with Portfolio Balance | High correlation |
Personal Loan is highly skewed (γ1 = 23.11911535) | Skewed |
Online Purchase Amount is highly skewed (γ1 = 20.3857396) | Skewed |
REF_NO has unique values | Unique |
children has 6208 (61.1%) zeros | Zeros |
Average Credit Card Transaction has 6190 (61.0%) zeros | Zeros |
Balance Transfer has 4392 (43.2%) zeros | Zeros |
Term Deposit has 5702 (56.1%) zeros | Zeros |
Life Insurance has 3061 (30.1%) zeros | Zeros |
Medical Insurance has 5033 (49.6%) zeros | Zeros |
Average A/C Balance has 3482 (34.3%) zeros | Zeros |
Personal Loan has 6382 (62.8%) zeros | Zeros |
Investment in Mutual Fund has 3257 (32.1%) zeros | Zeros |
Investment Tax Saving Bond has 6373 (62.8%) zeros | Zeros |
Home Loan has 6976 (68.7%) zeros | Zeros |
Online Purchase Amount has 7081 (69.7%) zeros | Zeros |
Investment in Commudity has 1021 (10.1%) zeros | Zeros |
Investment in Equity has 1139 (11.2%) zeros | Zeros |
Investment in Derivative has 539 (5.3%) zeros | Zeros |
| Distinct count | 10155 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5770.830822255047 |
|---|---|
| Minimum | 1 |
| Maximum | 11518 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 573.7 |
| Q1 | 2903.5 |
| median | 5770 |
| Q3 | 8665.5 |
| 95-th percentile | 10935.3 |
| Maximum | 11518 |
| Range | 11517 |
| Interquartile range (IQR) | 5762 |
Descriptive statistics
| Standard deviation | 3324.837813 |
|---|---|
| Coefficient of variation (CV) | 0.5761454314 |
| Kurtosis | -1.198925004 |
| Mean | 5770.830822 |
| Median Absolute Deviation (MAD) | 2882 |
| Skewness | -0.00552343364 |
| Sum | 58602787 |
| Variance | 11054546.49 |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 9502 | 1 | < 0.1% | |
| 7465 | 1 | < 0.1% | |
| 5416 | 1 | < 0.1% | |
| 9510 | 1 | < 0.1% | |
| 3363 | 1 | < 0.1% | |
| 1314 | 1 | < 0.1% | |
| 7457 | 1 | < 0.1% | |
| 5408 | 1 | < 0.1% | |
| 3355 | 1 | < 0.1% | |
| Other values (10145) | 10145 | 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 11518 | 1 | < 0.1% | |
| 11516 | 1 | < 0.1% | |
| 11514 | 1 | < 0.1% | |
| 11513 | 1 | < 0.1% | |
| 11512 | 1 | < 0.1% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6456917774495322 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros | 6208 |
| Zeros (%) | 61.1% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.9204737444 |
|---|---|
| Coefficient of variation (CV) | 1.425562128 |
| Kurtosis | 0.2182512517 |
| Mean | 0.6456917774 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.173637238 |
| Sum | 6557 |
| Variance | 0.847271914 |
| Value | Count | Frequency (%) | |
| 0 | 6208 | 61.1% | |
| 1 | 1848 | 18.2% | |
| 2 | 1607 | 15.8% | |
| 3 | 473 | 4.7% | |
| 4 | 19 | 0.2% |
| Value | Count | Frequency (%) | |
| 0 | 6208 | 61.1% | |
| 1 | 1848 | 18.2% | |
| 2 | 1607 | 15.8% | |
| 3 | 473 | 4.7% | |
| 4 | 19 | 0.2% |
| Value | Count | Frequency (%) | |
| 4 | 19 | 0.2% | |
| 3 | 473 | 4.7% | |
| 2 | 1607 | 15.8% | |
| 1 | 1848 | 18.2% | |
| 0 | 6208 | 61.1% |
age_band
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.3 KiB |
| 1 | |
|---|---|
| 2 | |
| 0 | |
| 3 | 465 |
| Value | Count | Frequency (%) | |
| 1 | 4666 | 45.9% | |
| 2 | 3578 | 35.2% | |
| 0 | 1446 | 14.2% | |
| 3 | 465 | 4.6% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
status
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.3 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 7757 | 76.4% | |
| 1 | 2398 | 23.6% |
occupation
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.3 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 5534 | 54.5% | |
| 1 | 4621 | 45.5% |
home_status
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.3 KiB |
| 1 | |
|---|---|
| 0 | 633 |
| Value | Count | Frequency (%) | |
| 1 | 9522 | 93.8% | |
| 0 | 633 | 6.2% |
family_income
Real number (ℝ≥0)
| Distinct count | 13 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.611619891678977 |
|---|---|
| Minimum | 4.0 |
| Maximum | 35.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 6.25 |
| Q1 | 13.5 |
| median | 23.5 |
| Q3 | 28.5 |
| 95-th percentile | 35 |
| Maximum | 35 |
| Range | 31 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 9.598150509 |
|---|---|
| Coefficient of variation (CV) | 0.4244786775 |
| Kurtosis | -1.135966584 |
| Mean | 22.61161989 |
| Median Absolute Deviation (MAD) | 8.5 |
| Skewness | -0.1962260335 |
| Sum | 229621 |
| Variance | 92.12449319 |
| Value | Count | Frequency (%) | |
| 35 | 2517 | 24.8% | |
| 26 | 1227 | 12.1% | |
| 28.5 | 994 | 9.8% | |
| 23.5 | 833 | 8.2% | |
| 18.5 | 683 | 6.7% | |
| 11 | 677 | 6.7% | |
| 16 | 634 | 6.2% | |
| 13.5 | 629 | 6.2% | |
| 21 | 590 | 5.8% | |
| 9 | 563 | 5.5% | |
| Other values (3) | 808 | 8.0% |
| Value | Count | Frequency (%) | |
| 4 | 278 | 2.7% | |
| 6.25 | 402 | 4.0% | |
| 9 | 563 | 5.5% | |
| 11 | 677 | 6.7% | |
| 13.5 | 629 | 6.2% |
| Value | Count | Frequency (%) | |
| 35 | 2517 | 24.8% | |
| 28.5 | 994 | 9.8% | |
| 26 | 1227 | 12.1% | |
| 23.5 | 833 | 8.2% | |
| 21 | 590 | 5.8% |
self_employed
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.3 KiB |
| 0 | |
|---|---|
| 1 | 719 |
| Value | Count | Frequency (%) | |
| 0 | 9436 | 92.9% | |
| 1 | 719 | 7.1% |
year_last_moved
Real number (ℝ≥0)
| Distinct count | 95 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1968.3763663220088 |
|---|---|
| Minimum | 0 |
| Maximum | 1999 |
| Zeros | 84 |
| Zeros (%) | 0.8% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1961 |
| Q1 | 1978 |
| median | 1988 |
| Q3 | 1994 |
| 95-th percentile | 1998 |
| Maximum | 1999 |
| Range | 1999 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 180.2022422 |
|---|---|
| Coefficient of variation (CV) | 0.09154867193 |
| Kurtosis | 114.838814 |
| Mean | 1968.376366 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -10.7823423 |
| Sum | 19988862 |
| Variance | 32472.84809 |
| Value | Count | Frequency (%) | |
| 1997 | 680 | 6.7% | |
| 1996 | 654 | 6.4% | |
| 1994 | 542 | 5.3% | |
| 1998 | 538 | 5.3% | |
| 1995 | 492 | 4.8% | |
| 1988 | 423 | 4.2% | |
| 1993 | 406 | 4.0% | |
| 1986 | 387 | 3.8% | |
| 1992 | 372 | 3.7% | |
| 1987 | 356 | 3.5% | |
| Other values (85) | 5305 | 52.2% |
| Value | Count | Frequency (%) | |
| 0 | 84 | 0.8% | |
| 1901 | 2 | < 0.1% | |
| 1902 | 2 | < 0.1% | |
| 1903 | 1 | < 0.1% | |
| 1904 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1999 | 65 | 0.6% | |
| 1998 | 538 | 5.3% | |
| 1997 | 680 | 6.7% | |
| 1996 | 654 | 6.4% | |
| 1995 | 492 | 4.8% |
| Distinct count | 1411 |
|---|---|
| Unique (%) | 13.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.44175677006401 |
|---|---|
| Minimum | 0.0 |
| Maximum | 662.26 |
| Zeros | 6190 |
| Zeros (%) | 61.0% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 23.98 |
| 95-th percentile | 130.567 |
| Maximum | 662.26 |
| Range | 662.26 |
| Interquartile range (IQR) | 23.98 |
Descriptive statistics
| Standard deviation | 50.87212745 |
|---|---|
| Coefficient of variation (CV) | 2.170149957 |
| Kurtosis | 18.50617043 |
| Mean | 23.44175677 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.619964534 |
| Sum | 238051.04 |
| Variance | 2587.973351 |
| Value | Count | Frequency (%) | |
| 0 | 6190 | 61.0% | |
| 19.99 | 147 | 1.4% | |
| 9.99 | 108 | 1.1% | |
| 11.99 | 70 | 0.7% | |
| 24.99 | 60 | 0.6% | |
| 19.49 | 56 | 0.6% | |
| 15.99 | 55 | 0.5% | |
| 4.99 | 54 | 0.5% | |
| 14.99 | 54 | 0.5% | |
| 9.49 | 50 | 0.5% | |
| Other values (1401) | 3311 | 32.6% |
| Value | Count | Frequency (%) | |
| 0 | 6190 | 61.0% | |
| 0.01 | 45 | 0.4% | |
| 0.02 | 10 | 0.1% | |
| 0.03 | 1 | < 0.1% | |
| 0.04 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 662.26 | 1 | < 0.1% | |
| 592.36 | 1 | < 0.1% | |
| 571.74 | 1 | < 0.1% | |
| 565.36 | 1 | < 0.1% | |
| 481.36 | 1 | < 0.1% |
| Distinct count | 2183 |
|---|---|
| Unique (%) | 21.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.41775972427376 |
|---|---|
| Minimum | 0.0 |
| Maximum | 2951.76 |
| Zeros | 4392 |
| Zeros (%) | 43.2% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 17.96 |
| Q3 | 65.385 |
| 95-th percentile | 188.96 |
| Maximum | 2951.76 |
| Range | 2951.76 |
| Interquartile range (IQR) | 65.385 |
Descriptive statistics
| Standard deviation | 78.47760933 |
|---|---|
| Coefficient of variation (CV) | 1.690680675 |
| Kurtosis | 193.3229914 |
| Mean | 46.41775972 |
| Median Absolute Deviation (MAD) | 17.96 |
| Skewness | 7.210658269 |
| Sum | 471372.35 |
| Variance | 6158.735167 |
| Value | Count | Frequency (%) | |
| 0 | 4392 | 43.2% | |
| 0.01 | 189 | 1.9% | |
| 24.99 | 167 | 1.6% | |
| 29.99 | 148 | 1.5% | |
| 19.99 | 87 | 0.9% | |
| 34.99 | 77 | 0.8% | |
| 25.99 | 71 | 0.7% | |
| 0.51 | 59 | 0.6% | |
| 24.49 | 53 | 0.5% | |
| 44.99 | 52 | 0.5% | |
| Other values (2173) | 4860 | 47.9% |
| Value | Count | Frequency (%) | |
| 0 | 4392 | 43.2% | |
| 0.01 | 189 | 1.9% | |
| 0.02 | 47 | 0.5% | |
| 0.03 | 13 | 0.1% | |
| 0.04 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2951.76 | 1 | < 0.1% | |
| 860.83 | 1 | < 0.1% | |
| 858.78 | 1 | < 0.1% | |
| 749.38 | 1 | < 0.1% | |
| 659.21 | 1 | < 0.1% |
| Distinct count | 1419 |
|---|---|
| Unique (%) | 14.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.579851304775975 |
|---|---|
| Minimum | 0.0 |
| Maximum | 784.82 |
| Zeros | 5702 |
| Zeros (%) | 56.1% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 34.99 |
| 95-th percentile | 126.926 |
| Maximum | 784.82 |
| Range | 784.82 |
| Interquartile range (IQR) | 34.99 |
Descriptive statistics
| Standard deviation | 53.95254985 |
|---|---|
| Coefficient of variation (CV) | 1.956230629 |
| Kurtosis | 26.12492154 |
| Mean | 27.5798513 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.997495289 |
| Sum | 280073.39 |
| Variance | 2910.877636 |
| Value | Count | Frequency (%) | |
| 0 | 5702 | 56.1% | |
| 24.99 | 158 | 1.6% | |
| 29.99 | 154 | 1.5% | |
| 19.99 | 121 | 1.2% | |
| 14.99 | 89 | 0.9% | |
| 34.99 | 84 | 0.8% | |
| 9.99 | 80 | 0.8% | |
| 0.01 | 74 | 0.7% | |
| 29.49 | 54 | 0.5% | |
| 24.49 | 54 | 0.5% | |
| Other values (1409) | 3585 | 35.3% |
| Value | Count | Frequency (%) | |
| 0 | 5702 | 56.1% | |
| 0.01 | 74 | 0.7% | |
| 0.02 | 14 | 0.1% | |
| 0.03 | 2 | < 0.1% | |
| 0.51 | 33 | 0.3% |
| Value | Count | Frequency (%) | |
| 784.82 | 1 | < 0.1% | |
| 738.67 | 1 | < 0.1% | |
| 716.12 | 1 | < 0.1% | |
| 597.76 | 1 | < 0.1% | |
| 539.18 | 1 | < 0.1% |
| Distinct count | 3111 |
|---|---|
| Unique (%) | 30.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66.24213096996553 |
|---|---|
| Minimum | 0.0 |
| Maximum | 2930.41 |
| Zeros | 3061 |
| Zeros (%) | 30.1% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 31.98 |
| Q3 | 94.39 |
| 95-th percentile | 243.654 |
| Maximum | 2930.41 |
| Range | 2930.41 |
| Interquartile range (IQR) | 94.39 |
Descriptive statistics
| Standard deviation | 95.54531646 |
|---|---|
| Coefficient of variation (CV) | 1.442364777 |
| Kurtosis | 87.69084691 |
| Mean | 66.24213097 |
| Median Absolute Deviation (MAD) | 31.98 |
| Skewness | 4.910322111 |
| Sum | 672688.84 |
| Variance | 9128.907498 |
| Value | Count | Frequency (%) | |
| 0 | 3061 | 30.1% | |
| 0.01 | 92 | 0.9% | |
| 27.99 | 69 | 0.7% | |
| 29.99 | 65 | 0.6% | |
| 24.99 | 55 | 0.5% | |
| 25.99 | 54 | 0.5% | |
| 17.99 | 53 | 0.5% | |
| 22.99 | 53 | 0.5% | |
| 19.99 | 51 | 0.5% | |
| 34.99 | 50 | 0.5% | |
| Other values (3101) | 6552 | 64.5% |
| Value | Count | Frequency (%) | |
| 0 | 3061 | 30.1% | |
| 0.01 | 92 | 0.9% | |
| 0.02 | 30 | 0.3% | |
| 0.03 | 7 | 0.1% | |
| 0.08 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2930.41 | 1 | < 0.1% | |
| 1005.53 | 1 | < 0.1% | |
| 825.02 | 1 | < 0.1% | |
| 817.63 | 1 | < 0.1% | |
| 805.28 | 1 | < 0.1% |
| Distinct count | 1589 |
|---|---|
| Unique (%) | 15.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.142050221565732 |
|---|---|
| Minimum | 0.0 |
| Maximum | 591.04 |
| Zeros | 5033 |
| Zeros (%) | 49.6% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.51 |
| Q3 | 27.47 |
| 95-th percentile | 82.439 |
| Maximum | 591.04 |
| Range | 591.04 |
| Interquartile range (IQR) | 27.47 |
Descriptive statistics
| Standard deviation | 32.45185602 |
|---|---|
| Coefficient of variation (CV) | 1.695317672 |
| Kurtosis | 20.0135372 |
| Mean | 19.14205022 |
| Median Absolute Deviation (MAD) | 0.51 |
| Skewness | 3.242102818 |
| Sum | 194387.52 |
| Variance | 1053.122959 |
| Value | Count | Frequency (%) | |
| 0 | 5033 | 49.6% | |
| 9.99 | 214 | 2.1% | |
| 9.49 | 82 | 0.8% | |
| 10.99 | 69 | 0.7% | |
| 29.99 | 67 | 0.7% | |
| 7.49 | 65 | 0.6% | |
| 6.99 | 62 | 0.6% | |
| 19.99 | 61 | 0.6% | |
| 4.99 | 61 | 0.6% | |
| 19.98 | 50 | 0.5% | |
| Other values (1579) | 4391 | 43.2% |
| Value | Count | Frequency (%) | |
| 0 | 5033 | 49.6% | |
| 0.01 | 36 | 0.4% | |
| 0.02 | 6 | 0.1% | |
| 0.48 | 1 | < 0.1% | |
| 0.51 | 9 | 0.1% |
| Value | Count | Frequency (%) | |
| 591.04 | 1 | < 0.1% | |
| 350.71 | 1 | < 0.1% | |
| 306.85 | 1 | < 0.1% | |
| 296.01 | 1 | < 0.1% | |
| 294.76 | 1 | < 0.1% |
| Distinct count | 2223 |
|---|---|
| Unique (%) | 21.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.084965041851305 |
|---|---|
| Minimum | 0.0 |
| Maximum | 626.24 |
| Zeros | 3482 |
| Zeros (%) | 34.3% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 14.99 |
| Q3 | 46.48 |
| 95-th percentile | 120.342 |
| Maximum | 626.24 |
| Range | 626.24 |
| Interquartile range (IQR) | 46.48 |
Descriptive statistics
| Standard deviation | 45.48661367 |
|---|---|
| Coefficient of variation (CV) | 1.41769248 |
| Kurtosis | 13.9870297 |
| Mean | 32.08496504 |
| Median Absolute Deviation (MAD) | 14.99 |
| Skewness | 2.777490494 |
| Sum | 325822.82 |
| Variance | 2069.032023 |
| Value | Count | Frequency (%) | |
| 0 | 3482 | 34.3% | |
| 4.99 | 144 | 1.4% | |
| 29.99 | 136 | 1.3% | |
| 11.99 | 106 | 1.0% | |
| 9.99 | 100 | 1.0% | |
| 14.99 | 91 | 0.9% | |
| 24.99 | 87 | 0.9% | |
| 34.99 | 63 | 0.6% | |
| 2.99 | 56 | 0.6% | |
| 3.49 | 52 | 0.5% | |
| Other values (2213) | 5838 | 57.5% |
| Value | Count | Frequency (%) | |
| 0 | 3482 | 34.3% | |
| 0.01 | 38 | 0.4% | |
| 0.02 | 4 | < 0.1% | |
| 0.03 | 1 | < 0.1% | |
| 0.05 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 626.24 | 1 | < 0.1% | |
| 616.17 | 1 | < 0.1% | |
| 415.14 | 1 | < 0.1% | |
| 410.71 | 1 | < 0.1% | |
| 402.6 | 1 | < 0.1% |
| Distinct count | 1760 |
|---|---|
| Unique (%) | 17.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.00600295420975 |
|---|---|
| Minimum | 0.0 |
| Maximum | 4905.93 |
| Zeros | 6382 |
| Zeros (%) | 62.8% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 21.48 |
| 95-th percentile | 134.368 |
| Maximum | 4905.93 |
| Range | 4905.93 |
| Interquartile range (IQR) | 21.48 |
Descriptive statistics
| Standard deviation | 84.27574321 |
|---|---|
| Coefficient of variation (CV) | 3.240626534 |
| Kurtosis | 1149.240577 |
| Mean | 26.00600295 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 23.11911535 |
| Sum | 264090.96 |
| Variance | 7102.400894 |
| Value | Count | Frequency (%) | |
| 0 | 6382 | 62.8% | |
| 15.99 | 53 | 0.5% | |
| 14.99 | 42 | 0.4% | |
| 13.99 | 37 | 0.4% | |
| 6.99 | 37 | 0.4% | |
| 5.99 | 36 | 0.4% | |
| 11.99 | 33 | 0.3% | |
| 0.01 | 32 | 0.3% | |
| 8.99 | 31 | 0.3% | |
| 17.99 | 28 | 0.3% | |
| Other values (1750) | 3444 | 33.9% |
| Value | Count | Frequency (%) | |
| 0 | 6382 | 62.8% | |
| 0.01 | 32 | 0.3% | |
| 0.02 | 9 | 0.1% | |
| 0.51 | 7 | 0.1% | |
| 0.52 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4905.93 | 1 | < 0.1% | |
| 1645.38 | 1 | < 0.1% | |
| 1309.08 | 1 | < 0.1% | |
| 1304.01 | 1 | < 0.1% | |
| 1280.2 | 1 | < 0.1% |
| Distinct count | 2470 |
|---|---|
| Unique (%) | 24.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42.339697685869034 |
|---|---|
| Minimum | 0.0 |
| Maximum | 2561.27 |
| Zeros | 3257 |
| Zeros (%) | 32.1% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 23.48 |
| Q3 | 59.555 |
| 95-th percentile | 150.903 |
| Maximum | 2561.27 |
| Range | 2561.27 |
| Interquartile range (IQR) | 59.555 |
Descriptive statistics
| Standard deviation | 63.89889948 |
|---|---|
| Coefficient of variation (CV) | 1.509195931 |
| Kurtosis | 248.7072951 |
| Mean | 42.33969769 |
| Median Absolute Deviation (MAD) | 23.48 |
| Skewness | 8.398389891 |
| Sum | 429959.63 |
| Variance | 4083.069355 |
| Value | Count | Frequency (%) | |
| 0 | 3257 | 32.1% | |
| 11.99 | 136 | 1.3% | |
| 9.99 | 100 | 1.0% | |
| 13.99 | 87 | 0.9% | |
| 23.98 | 77 | 0.8% | |
| 19.98 | 66 | 0.6% | |
| 23.48 | 65 | 0.6% | |
| 11.49 | 59 | 0.6% | |
| 0.01 | 49 | 0.5% | |
| 17.99 | 47 | 0.5% | |
| Other values (2460) | 6212 | 61.2% |
| Value | Count | Frequency (%) | |
| 0 | 3257 | 32.1% | |
| 0.01 | 49 | 0.5% | |
| 0.02 | 18 | 0.2% | |
| 0.03 | 3 | < 0.1% | |
| 0.04 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2561.27 | 1 | < 0.1% | |
| 765.03 | 1 | < 0.1% | |
| 648.54 | 1 | < 0.1% | |
| 646.39 | 1 | < 0.1% | |
| 633.89 | 1 | < 0.1% |
| Distinct count | 832 |
|---|---|
| Unique (%) | 8.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.112070901033974 |
|---|---|
| Minimum | 0.0 |
| Maximum | 156.87 |
| Zeros | 6373 |
| Zeros (%) | 62.8% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 5.975 |
| 95-th percentile | 32.543 |
| Maximum | 156.87 |
| Range | 156.87 |
| Interquartile range (IQR) | 5.975 |
Descriptive statistics
| Standard deviation | 12.83367452 |
|---|---|
| Coefficient of variation (CV) | 2.099726054 |
| Kurtosis | 14.82400131 |
| Mean | 6.112070901 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.234383223 |
| Sum | 62068.08 |
| Variance | 164.7032016 |
| Value | Count | Frequency (%) | |
| 0 | 6373 | 62.8% | |
| 1 | 278 | 2.7% | |
| 2 | 128 | 1.3% | |
| 4.99 | 124 | 1.2% | |
| 9.99 | 104 | 1.0% | |
| 19.99 | 87 | 0.9% | |
| 4.49 | 84 | 0.8% | |
| 2.49 | 74 | 0.7% | |
| 2.99 | 65 | 0.6% | |
| 3 | 60 | 0.6% | |
| Other values (822) | 2778 | 27.4% |
| Value | Count | Frequency (%) | |
| 0 | 6373 | 62.8% | |
| 0.01 | 3 | < 0.1% | |
| 0.1 | 2 | < 0.1% | |
| 0.2 | 5 | < 0.1% | |
| 0.45 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 156.87 | 1 | < 0.1% | |
| 138.56 | 1 | < 0.1% | |
| 124.76 | 1 | < 0.1% | |
| 123.34 | 1 | < 0.1% | |
| 121.44 | 1 | < 0.1% |
| Distinct count | 884 |
|---|---|
| Unique (%) | 8.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.482001969473165 |
|---|---|
| Minimum | 0.0 |
| Maximum | 162.35 |
| Zeros | 6976 |
| Zeros (%) | 68.7% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4.49 |
| 95-th percentile | 24.46 |
| Maximum | 162.35 |
| Range | 162.35 |
| Interquartile range (IQR) | 4.49 |
Descriptive statistics
| Standard deviation | 9.982640872 |
|---|---|
| Coefficient of variation (CV) | 2.227272754 |
| Kurtosis | 24.83350195 |
| Mean | 4.482001969 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.888050096 |
| Sum | 45514.73 |
| Variance | 99.65311877 |
| Value | Count | Frequency (%) | |
| 0 | 6976 | 68.7% | |
| 4.99 | 121 | 1.2% | |
| 9.99 | 93 | 0.9% | |
| 4.49 | 87 | 0.9% | |
| 3.99 | 67 | 0.7% | |
| 3.49 | 61 | 0.6% | |
| 7.99 | 49 | 0.5% | |
| 2.99 | 48 | 0.5% | |
| 1.99 | 47 | 0.5% | |
| 5.99 | 46 | 0.5% | |
| Other values (874) | 2560 | 25.2% |
| Value | Count | Frequency (%) | |
| 0 | 6976 | 68.7% | |
| 0.01 | 9 | 0.1% | |
| 0.5 | 3 | < 0.1% | |
| 0.51 | 3 | < 0.1% | |
| 0.74 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 162.35 | 1 | < 0.1% | |
| 122.67 | 1 | < 0.1% | |
| 121.92 | 1 | < 0.1% | |
| 114.39 | 1 | < 0.1% | |
| 110.17 | 1 | < 0.1% |
| Distinct count | 1319 |
|---|---|
| Unique (%) | 13.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.162772033481044 |
|---|---|
| Minimum | 0.0 |
| Maximum | 4306.42 |
| Zeros | 7081 |
| Zeros (%) | 69.7% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 7.98 |
| 95-th percentile | 93.453 |
| Maximum | 4306.42 |
| Range | 4306.42 |
| Interquartile range (IQR) | 7.98 |
Descriptive statistics
| Standard deviation | 89.66626341 |
|---|---|
| Coefficient of variation (CV) | 4.679190634 |
| Kurtosis | 708.8697201 |
| Mean | 19.16277203 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 20.3857396 |
| Sum | 194597.95 |
| Variance | 8040.038795 |
| Value | Count | Frequency (%) | |
| 0 | 7081 | 69.7% | |
| 3.99 | 61 | 0.6% | |
| 11.99 | 59 | 0.6% | |
| 14.99 | 41 | 0.4% | |
| 7.99 | 41 | 0.4% | |
| 4.49 | 39 | 0.4% | |
| 4.99 | 37 | 0.4% | |
| 2.99 | 36 | 0.4% | |
| 9.99 | 33 | 0.3% | |
| 19.99 | 29 | 0.3% | |
| Other values (1309) | 2698 | 26.6% |
| Value | Count | Frequency (%) | |
| 0 | 7081 | 69.7% | |
| 0.01 | 19 | 0.2% | |
| 0.02 | 5 | < 0.1% | |
| 0.04 | 1 | < 0.1% | |
| 0.05 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4306.42 | 1 | < 0.1% | |
| 2808.8 | 1 | < 0.1% | |
| 2142.62 | 1 | < 0.1% | |
| 2033.85 | 1 | < 0.1% | |
| 1652.45 | 1 | < 0.1% |
Revenue Grid
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.3 KiB |
| 2 | |
|---|---|
| 1 | 1086 |
| Value | Count | Frequency (%) | |
| 2 | 9069 | 89.3% | |
| 1 | 1086 | 10.7% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
gender
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.3 KiB |
| 0 | |
|---|---|
| 1 | |
| 2 | 35 |
| Value | Count | Frequency (%) | |
| 0 | 7634 | 75.2% | |
| 1 | 2486 | 24.5% | |
| 2 | 35 | 0.3% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 3558 |
|---|---|
| Unique (%) | 35.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.56488626292467 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1231.09 |
| Zeros | 1021 |
| Zeros (%) | 10.1% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 8.23 |
| median | 23.98 |
| Q3 | 50.79 |
| 95-th percentile | 115.863 |
| Maximum | 1231.09 |
| Range | 1231.09 |
| Interquartile range (IQR) | 42.56 |
Descriptive statistics
| Standard deviation | 42.27053025 |
|---|---|
| Coefficient of variation (CV) | 1.156041617 |
| Kurtosis | 69.90895292 |
| Mean | 36.56488626 |
| Median Absolute Deviation (MAD) | 18.69 |
| Skewness | 4.299542009 |
| Sum | 371316.42 |
| Variance | 1786.797728 |
| Value | Count | Frequency (%) | |
| 0 | 1021 | 10.1% | |
| 4 | 60 | 0.6% | |
| 5 | 55 | 0.5% | |
| 6 | 53 | 0.5% | |
| 2 | 45 | 0.4% | |
| 7 | 44 | 0.4% | |
| 3 | 34 | 0.3% | |
| 3.9 | 33 | 0.3% | |
| 3.2 | 32 | 0.3% | |
| 3.6 | 32 | 0.3% | |
| Other values (3548) | 8746 | 86.1% |
| Value | Count | Frequency (%) | |
| 0 | 1021 | 10.1% | |
| 0.01 | 6 | 0.1% | |
| 0.02 | 1 | < 0.1% | |
| 0.1 | 28 | 0.3% | |
| 0.12 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1231.09 | 1 | < 0.1% | |
| 412.96 | 1 | < 0.1% | |
| 385.24 | 1 | < 0.1% | |
| 384.17 | 1 | < 0.1% | |
| 373.3 | 1 | < 0.1% |
| Distinct count | 3250 |
|---|---|
| Unique (%) | 32.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.69869423929099 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1279.1 |
| Zeros | 1139 |
| Zeros (%) | 11.2% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4.67 |
| median | 12.98 |
| Q3 | 28.3 |
| 95-th percentile | 69.756 |
| Maximum | 1279.1 |
| Range | 1279.1 |
| Interquartile range (IQR) | 23.63 |
Descriptive statistics
| Standard deviation | 31.89384106 |
|---|---|
| Coefficient of variation (CV) | 1.469850706 |
| Kurtosis | 285.6367969 |
| Mean | 21.69869424 |
| Median Absolute Deviation (MAD) | 10.09 |
| Skewness | 10.27230932 |
| Sum | 220350.24 |
| Variance | 1017.217097 |
| Value | Count | Frequency (%) | |
| 0 | 1139 | 11.2% | |
| 3.33 | 72 | 0.7% | |
| 2 | 56 | 0.6% | |
| 5 | 53 | 0.5% | |
| 1.67 | 46 | 0.5% | |
| 2.5 | 43 | 0.4% | |
| 4 | 37 | 0.4% | |
| 6.66 | 36 | 0.4% | |
| 4.17 | 34 | 0.3% | |
| 0.83 | 32 | 0.3% | |
| Other values (3240) | 8607 | 84.8% |
| Value | Count | Frequency (%) | |
| 0 | 1139 | 11.2% | |
| 0.01 | 1 | < 0.1% | |
| 0.02 | 1 | < 0.1% | |
| 0.08 | 3 | < 0.1% | |
| 0.09 | 12 | 0.1% |
| Value | Count | Frequency (%) | |
| 1279.1 | 1 | < 0.1% | |
| 717.74 | 1 | < 0.1% | |
| 556.19 | 1 | < 0.1% | |
| 434.15 | 1 | < 0.1% | |
| 419.99 | 1 | < 0.1% |
| Distinct count | 3796 |
|---|---|
| Unique (%) | 37.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.988646971935005 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1771.16 |
| Zeros | 539 |
| Zeros (%) | 5.3% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 8.74 |
| median | 21.34 |
| Q3 | 42.98 |
| 95-th percentile | 98.176 |
| Maximum | 1771.16 |
| Range | 1771.16 |
| Interquartile range (IQR) | 34.24 |
Descriptive statistics
| Standard deviation | 39.10634725 |
|---|---|
| Coefficient of variation (CV) | 1.222507075 |
| Kurtosis | 395.8226205 |
| Mean | 31.98864697 |
| Median Absolute Deviation (MAD) | 15.09 |
| Skewness | 10.81440814 |
| Sum | 324844.71 |
| Variance | 1529.306395 |
| Value | Count | Frequency (%) | |
| 0 | 539 | 5.3% | |
| 3.33 | 56 | 0.6% | |
| 5 | 51 | 0.5% | |
| 2 | 39 | 0.4% | |
| 1.67 | 35 | 0.3% | |
| 4.91 | 33 | 0.3% | |
| 5.83 | 31 | 0.3% | |
| 2.5 | 30 | 0.3% | |
| 4.17 | 28 | 0.3% | |
| 6.58 | 28 | 0.3% | |
| Other values (3786) | 9285 | 91.4% |
| Value | Count | Frequency (%) | |
| 0 | 539 | 5.3% | |
| 0.01 | 2 | < 0.1% | |
| 0.09 | 13 | 0.1% | |
| 0.1 | 1 | < 0.1% | |
| 0.17 | 11 | 0.1% |
| Value | Count | Frequency (%) | |
| 1771.16 | 1 | < 0.1% | |
| 533.98 | 1 | < 0.1% | |
| 456.12 | 1 | < 0.1% | |
| 421.55 | 1 | < 0.1% | |
| 411.39 | 1 | < 0.1% |
| Distinct count | 8317 |
|---|---|
| Unique (%) | 81.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90.4602373215165 |
|---|---|
| Minimum | -78.43 |
| Maximum | 4283.56 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 79.3 KiB |
Quantile statistics
| Minimum | -78.43 |
|---|---|
| 5-th percentile | -13.474 |
| Q1 | 26.605 |
| median | 66.2 |
| Q3 | 125.935 |
| 95-th percentile | 273.305 |
| Maximum | 4283.56 |
| Range | 4361.99 |
| Interquartile range (IQR) | 99.33 |
Descriptive statistics
| Standard deviation | 107.2654754 |
|---|---|
| Coefficient of variation (CV) | 1.185774861 |
| Kurtosis | 236.9206806 |
| Mean | 90.46023732 |
| Median Absolute Deviation (MAD) | 46.14 |
| Skewness | 7.724671171 |
| Sum | 918623.71 |
| Variance | 11505.8822 |
| Value | Count | Frequency (%) | |
| 0.36 | 6 | 0.1% | |
| 53.26 | 5 | < 0.1% | |
| 57.9 | 5 | < 0.1% | |
| 30 | 5 | < 0.1% | |
| 71.45 | 5 | < 0.1% | |
| 47.75 | 5 | < 0.1% | |
| 67.79 | 5 | < 0.1% | |
| 118.52 | 4 | < 0.1% | |
| 77.14 | 4 | < 0.1% | |
| 77.41 | 4 | < 0.1% | |
| Other values (8307) | 10107 | 99.5% |
| Value | Count | Frequency (%) | |
| -78.43 | 1 | < 0.1% | |
| -77.23 | 1 | < 0.1% | |
| -76.35 | 1 | < 0.1% | |
| -74.07 | 1 | < 0.1% | |
| -73.35 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4283.56 | 1 | < 0.1% | |
| 1109.57 | 1 | < 0.1% | |
| 1097.44 | 1 | < 0.1% | |
| 1053.8 | 1 | < 0.1% | |
| 1024.68 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| REF_NO | children | age_band | status | occupation | home_status | family_income | self_employed | year_last_moved | Average Credit Card Transaction | Balance Transfer | Term Deposit | Life Insurance | Medical Insurance | Average A/C Balance | Personal Loan | Investment in Mutual Fund | Investment Tax Saving Bond | Home Loan | Online Purchase Amount | Revenue Grid | gender | Investment in Commudity | Investment in Equity | Investment in Derivative | Portfolio Balance | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 0 | 2 | 0 | 0 | 1 | 16.0 | 0 | 1972 | 148.44 | 142.95 | 0.00 | 81.96 | 0.00 | 29.99 | 0.00 | 61.95 | 19.99 | 0.00 | 0.00 | 1 | 0 | 74.67 | 18.66 | 32.32 | 89.43 |
| 1 | 2 | 0 | 2 | 1 | 1 | 1 | 26.0 | 0 | 1998 | 0.00 | 74.98 | 0.00 | 25.99 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2 | 0 | 20.19 | 0.00 | 4.33 | 22.78 |
| 2 | 3 | 0 | 0 | 1 | 0 | 1 | 28.5 | 1 | 1996 | 0.00 | 166.44 | 20.99 | 291.37 | 11.48 | 166.94 | 0.00 | 15.99 | 0.00 | 3.49 | 0.00 | 2 | 1 | 98.06 | 31.07 | 80.96 | 171.78 |
| 3 | 5 | 0 | 0 | 1 | 0 | 1 | 13.5 | 0 | 1997 | 0.00 | 0.00 | 0.00 | 20.49 | 0.00 | 39.46 | 0.00 | 45.44 | 0.00 | 0.00 | 0.00 | 2 | 0 | 4.10 | 14.15 | 17.57 | -41.70 |
| 4 | 6 | 0 | 1 | 0 | 0 | 1 | 28.5 | 0 | 1995 | 73.45 | 57.96 | 0.00 | 177.42 | 41.95 | 39.47 | 10.97 | 212.84 | 0.00 | 45.91 | 25.98 | 2 | 0 | 70.16 | 55.86 | 80.44 | 235.02 |
| 5 | 7 | 0 | 2 | 0 | 0 | 1 | 16.0 | 0 | 1984 | 0.00 | 125.45 | 0.00 | 129.96 | 0.00 | 0.00 | 0.00 | 88.95 | 0.00 | 0.00 | 0.00 | 2 | 0 | 51.08 | 14.83 | 36.49 | 72.30 |
| 6 | 8 | 0 | 1 | 0 | 0 | 1 | 35.0 | 0 | 1985 | 0.00 | 29.48 | 97.42 | 0.02 | 39.45 | 63.97 | 0.00 | 49.42 | 0.00 | 0.00 | 0.00 | 2 | 0 | 33.27 | 18.90 | 25.48 | 115.28 |
| 7 | 9 | 1 | 1 | 0 | 0 | 1 | 35.0 | 0 | 1993 | 0.00 | 0.01 | 175.88 | 67.47 | 0.00 | 110.95 | 86.39 | 74.93 | 41.71 | 35.41 | 11.99 | 2 | 0 | 48.67 | 60.23 | 63.58 | 162.40 |
| 8 | 10 | 0 | 1 | 1 | 0 | 1 | 16.0 | 0 | 1995 | 25.00 | 0.00 | 76.45 | 24.99 | 0.00 | 87.93 | 0.00 | 253.27 | 12.48 | 7.21 | 8.99 | 2 | 1 | 25.29 | 61.65 | 63.11 | 105.20 |
| 9 | 11 | 2 | 1 | 0 | 0 | 1 | 35.0 | 0 | 1993 | 0.00 | 74.98 | 62.98 | 141.91 | 44.48 | 0.00 | 13.99 | 49.95 | 0.00 | 10.49 | 7.98 | 2 | 0 | 64.87 | 13.74 | 41.72 | 93.09 |
Last rows
| REF_NO | children | age_band | status | occupation | home_status | family_income | self_employed | year_last_moved | Average Credit Card Transaction | Balance Transfer | Term Deposit | Life Insurance | Medical Insurance | Average A/C Balance | Personal Loan | Investment in Mutual Fund | Investment Tax Saving Bond | Home Loan | Online Purchase Amount | Revenue Grid | gender | Investment in Commudity | Investment in Equity | Investment in Derivative | Portfolio Balance | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10145 | 11505 | 0 | 2 | 0 | 0 | 1 | 28.50 | 0 | 1976 | 0.00 | 0.00 | 0.00 | 17.47 | 0.00 | 0.00 | 0.00 | 37.47 | 4.99 | 18.72 | 3.49 | 2 | 0 | 3.49 | 10.78 | 9.99 | 46.21 |
| 10146 | 11506 | 0 | 1 | 0 | 1 | 1 | 26.00 | 0 | 1969 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 39.49 | 0.00 | 0.00 | 1 | 0 | 0.00 | 6.58 | 6.58 | 46.86 |
| 10147 | 11507 | 3 | 1 | 1 | 1 | 1 | 26.00 | 0 | 1994 | 0.00 | 0.00 | 0.00 | 270.84 | 0.00 | 5.48 | 0.00 | 35.97 | 0.00 | 0.00 | 0.00 | 1 | 0 | 54.17 | 6.91 | 52.05 | 138.70 |
| 10148 | 11509 | 0 | 2 | 0 | 1 | 1 | 6.25 | 0 | 1978 | 9.99 | 24.49 | 29.48 | 13.99 | 24.99 | 29.99 | 0.00 | 11.99 | 0.00 | 7.49 | 0.00 | 2 | 0 | 20.59 | 8.25 | 13.49 | 61.10 |
| 10149 | 11511 | 0 | 2 | 0 | 1 | 1 | 26.00 | 1 | 1982 | 21.98 | 1.03 | 171.90 | 197.32 | 42.44 | 48.33 | 24.98 | 9.99 | 9.30 | 11.97 | 48.98 | 2 | 1 | 86.93 | 25.59 | 55.39 | 170.07 |
| 10150 | 11512 | 1 | 1 | 0 | 0 | 1 | 28.50 | 0 | 1972 | 0.00 | 0.00 | 0.00 | 29.97 | 6.49 | 0.00 | 8.99 | 7.49 | 4.49 | 0.00 | 0.00 | 2 | 0 | 7.29 | 3.50 | 9.57 | 10.23 |
| 10151 | 11513 | 0 | 1 | 0 | 0 | 0 | 23.50 | 0 | 1988 | 0.00 | 110.95 | 0.00 | 200.41 | 0.00 | 2.99 | 0.00 | 14.99 | 0.00 | 0.00 | 0.00 | 2 | 0 | 62.27 | 3.00 | 36.40 | 102.62 |
| 10152 | 11514 | 2 | 1 | 0 | 1 | 1 | 35.00 | 0 | 1992 | 124.93 | 0.00 | 54.48 | 0.00 | 84.42 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2 | 0 | 52.77 | 0.00 | 14.07 | 76.18 |
| 10153 | 11516 | 0 | 2 | 0 | 1 | 1 | 9.00 | 0 | 1970 | 0.00 | 35.98 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 9.98 | 0.00 | 7.98 | 0.00 | 2 | 0 | 7.20 | 2.99 | 1.66 | 4.79 |
| 10154 | 11518 | 1 | 1 | 0 | 1 | 1 | 26.00 | 0 | 1996 | 0.00 | 40.46 | 0.00 | 310.24 | 9.98 | 105.96 | 106.94 | 43.46 | 19.49 | 0.00 | 0.00 | 2 | 0 | 72.14 | 45.98 | 99.35 | 227.12 |